1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Threading.Tasks;
6 using System.Data;
7
8 namespace SoftQuanLyNhaHang.Models
9 {
10 class BanMod
11 {
12 protected string IdBan { get; set; }
13 protected string TenKhuVuc { get; set; }
14 protected string TenBan { get; set; }
15 protected string DienGiai { get; set; }
16 protected string TrangThai { get; set; }
17 public BanMod(string _IdBan)
18 {
19 IdBan = _IdBan;
20 }
21 public BanMod()
22 {
23
24 }
25 public BanMod(string _idBan,string _tenKhuVuc,string _tenBan,string _dienGiai,string _trangThai)
26 {
27 this.IdBan=_idBan;
28 this.TenKhuVuc = _tenKhuVuc;
29 this.TenBan=_tenBan;
30 this.DienGiai=_dienGiai;
31 this.TrangThai=_trangThai;
32
33 }
34 public int InsertBan()
35 {
36 int i = 0;
37 string[] paras = new string[5] { "@IdBan", "@TenKhuVuc", "@TenBan", "@DienGiai", "@TrangThai" };
38 object[] values = new object[5] { IdBan, TenKhuVuc, TenBan, DienGiai, TrangThai };
39 i = Models.connection.Excute_Sql("spInsertBan", CommandType.StoredProcedure, paras, values);
40 return i;
41 }
42 public int UpdateBan()
43 {
44 int i = 0;
45 string[] paras = new string[5] { "@IdBan", "@TenKhuVuc", "@TenBan", "@DienGiai", "@TrangThai" };
46 object[] values = new object[5] { IdBan, TenKhuVuc, TenBan, DienGiai, TrangThai };
47 i = Models.connection.Excute_Sql("spUpdateBan", CommandType.StoredProcedure, paras, values);
48 return i;
49 }
50 public int DeleteBan()
51 {
52 int i = 0;
53 string[] paras = new string[1] { "@IdBan" };
54 object[] values = new object[1] { IdBan };
55 i = Models.connection.Excute_Sql("spDeleteBan", CommandType.StoredProcedure, paras, values);
56 return i;
57 }
58 public static DataSet FillDataSetBan()
59 {
60 return Models.connection.FillDataSet("spgetBan", CommandType.StoredProcedure);
61 }
62 // Chinh la no do
63 public static DataSet FillDataSetDanhSachBan_GoiMon()
64 {
65 return Models.connection.FillDataSet("spViewDanhSachBan_GoiMon", CommandType.StoredProcedure);
66 }
67 public static DataSet FillDataSetTenBan()
68 {
69 return Models.connection.FillDataSet("spgetTenBan", CommandType.StoredProcedure);
70 }
71 public DataSet FillDataSet_getBanByIdBan()
72 {
73 DataSet ds = new DataSet();
74 string[] paras = new string[1] { "@IdBan" };
75 object[] values = new object[1] { IdBan };
76 ds = Models.connection.FillDataSet("spgetBanByIdBan", CommandType.StoredProcedure, paras, values);
77 return ds;
78 }
79 }
80 }